Knowledge has a beginning but no end

Jasper iReport Property To Format Numbers properly in Excel Print

Ashvin Gami

2023-09-13 11:42:12

For excel to automatically detect what type of format the cell should be, add the following to your jrxml file at the top in the report properties section:

<property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
 

More details here

Related Articles
  • Jasper Support Links
  • Developer Links
  • How to convert HTML Tag to Plain text In Jasper Report
  • Page Exceeds to 2000limit in Jasper report